-
Re: Disable summary values on parent rows
Sorry I meant greater than =IF(COUNT(CHILDREN(Tasks@row)) > 1, "", rest of formula goes here1 · -
Re: Adding IF to a formula with IFERROR
=if([deployment complete]@row = 0,IFERROR(NETDAYS([Date of Verbal Agreement]@row, TODAY()), "")) Does that work?1 · -
Re: what is wrong in my formula working fine on excel?
Keyword is percentage. Did you try .80 instead of 80?1 · -
Re: CountIF to look for a partial piece of text
=COUNTIFS({QA WORKLOAD Date}, "BACKLOG", {QA WORKLOAD Com/CT}, "COM", {QA WORKLOAD WO ST}, "99", {QA WORKLOAD Description}, CONTAINS("SUB", @cell})) That one s…1 · -
Re: Combining Multiple Formulas
Yea not sure what result you're looking for but could you just add those countifs together in one formula? =COUNTIFS({IPT Consolidated Backlog Range 1}, @cell = "Sales Operations", {IPT Con…1 ·